INDEX A adding and dropping any index 1-11 algorithm caching 1-11 least-recently-used (LRU) 1-3 alternate collating sequence filename, specifying in description files A-19 specifying in description files A-15 autoincrement key 1-12 B backing up data files 5-18, 5-46 balanced index A-12 blank truncation, specifying in description files A-8 BLOG.CFG log file 5-45 BREBUILD utility. See Rebuild utility BREQUEST. See DOS Requester BROLLFWD utility. See Roll Forward utilit BROLLFWD, command format 5-47 BSETUP utility. See Setup utility BSPXCOM.NLM description 2-3 unloading 3-16, 3-17, 3-18 BSPXSTUB.NLM, unloading 3-16, 3-17, 3-18 BSTART.NCF 3-13 configuring to load BROUTER 3-13 BSTOP.NCF file 3-16, 3-17 Btrieve configuration options for 3-7 enhancements to v6.1 1-5 chunk operations 1-5 index balancing 1-6 locale-sensitive collating sequences 1-6, A-19 multiple alternate collating sequences (MACS) 1-6, A-19 no currency change option on inserts/updates 1-7 percentage operations 1-7 performing reads while creating an index 1-6 records larger than 64 KB 1-5 repeating-duplicatable key/linked-duplicatable key 1-7, A-16, A-17 requesters 1-7 sign trailing separate (STS) data type 1-7 Variable-Tail Allocation Tables (VATs) 1-6, A-12 enhancements to v6.x 1-8 adding and dropping any index 1-11 autoincrement key 1-12 caching algorithm 1-11 concurrent transactions 1-9 duplicate pointers 1-12 key segments 1-11 large data files 1-11 locking in extended operations 1-13 new file format 1-8 new Stat operation 1-13 online backups 1-9 optional renumbering of keys 1-12 shadow paging 1-10 specific key numbers allowed when creating file or index 1-12 support for referential integrity (RI) 1-13 update/delete records in key-only files 1-12 features 1-2 files, upgrading to v6.x 3-18 NLM configuring the 3-6 unloading the 3-16, 3-17, 3-18 Requester 4-1 using with DOS 4-1 using with OS/2 4-5 using with Windows 4-9 starting 3-17 stopping 3-18 Btrieve Monitor utility 5-1 Active Resources option of the 5-3, 5-4, 5-8 Available Options menu 5-3 Communication Statistics option of the 5-12, 5-13 loading (starting) 5-2 Resource Usage option of the 5-3, 5-10, 5-11 running the 5-2 running RCONSOLE 5-1 system requirements 5-1 Transaction Tracking System (TTS) flag 5-10 BUTIL utility. See Maintenance utility C Cache Allocation configuration option 3-11 cache buffer 1-3 caching algorithm 1-11 case-insensitive keys, specifying in description files A-16 codes, status B-1 collating sequences locale sensitive 1-6 multiple alternate 1-6 communication statistics, monitoring 5-12 communications programs, SPX 2-2 compressed record size, largest 3-9 concurrent transactions 1-9 features 1-10 configuration options Cache Allocation 3-11 Configure BSTART.NCF to Load BROUTER 3-13 Create Btrieve Files in Pre v6.x Format 3-12 for the DOS Requester 4-1 for the OS/2 Requester 4-6 for the Windows Requester 4-10 Largest Compressed Record Size 3-9 Largest Page Size 3-10 Largest Record Size 3-10 Logging of Selected Files 3-12 Number of Handles 3-8 Number of Locks 3-8 Number of Open Files 3-8 Number of Remote Sessions 3-11 Number of Transactions 3-9 Perform Index Balancing 3-11 Configure BSTART.NCF to Load BROUTER configuration option 3-13 contacting Novell xviii continuous operation and backups 5-18 and the Btrieve Maintenance utility commands 5-18 conventions symbolic xiv typographic xv copying data to an ASCII file 5-32, 5-35 Create Files in Pre-Btrieve v6.0 Format configuration option 3-12 creating an index while performing reads 1-6 D data compression, specifying in description files A-9 dynamic encryption and decryption 1-5 recovery using the RECOVER command 5-32 using the Roll Forward utility 5-43 security, enhancing in a network environment 1-5 types, sign trailing separate (STS) 1-7 data-only files, specifying in description files A-11 descending keys, specifying in description files A-15 description file elements Alternate Collating Sequence A-15 Alternate Collating Sequence Filename A-19 Balanced Index A-12 Blank Truncation A-8 Case-Insensitive Key A-16 Data Compression A-9 data-only files A-11 Descending Sort Order A-15 Duplicate Key Values A-14 Free Space Threshold A-11 Include Data A-11 Key Count A-9 Key Length A-13 Key Position A-13 Key Type A-14 Manual Key A-17 Modifiable Key Values A-14 Null Key A-18 Null Key Value A-18 overview 5-17 Page Preallocation A-10 Page Size A-10 Record Length A-7 Repeating Duplicates A-16 Replace Existing File A-11 Reserved Duplicate Pointer A-8 Segmented Key A-19 Variable-Length Records A-8 developer support xvii DOS Requester 4-1 configuration options 4-1 loading the 4-4 unloading the 4-5 duplicate keys linked 1-7 repeating 1-7 specifying in description files A-14 pointers 1-12 E extended operations, using locks with 1-13 F fast access to files 1-11 features, Btrieve file specifications 1-3 index maintenance 1-2 integrity controls 1-4 memory management 1-3 security controls 1-5 file-level transaction locking 1-9 files BLOG.CFG 5-45 description A-1 external index, creating 5-27 format (pre-v6.x) 1-8, 3-12 key-only 1-12, A-11 large data 1-11 NOVDB.INI 5-54 page size 1-11 pre-imaging 1-10 rebuilding existing 3-17 recovering damaged 5-32 size, maximum 1-3 specific key numbers allowed when creating 1-12 specifications 1-3 statistics 5-40 UPPER.ALT 5-25, A-3, A-5 free space threshold, specifying in description files A-11 H handles, number of 3-8 I index adding and dropping 1-11 balancing 1-6, 3-11, A-12 creating while performing reads 1-6 files, creating with the Maintenance utility 5-28 maintenance 1-2 specific key numbers allowed when creating 1-12 supplemental 5-38 integrity controls 1-4 international support xvi K key autoincrement 1-12 count, specifying in description files A-9 length, specifying in description files A-13 optional renumbering 1-12 position, specifying in description files A-13 repeating-duplicatable/linked-duplicatable 1-7, A-16, A-17 segments 1-11 types, specifying in description files A-14 values case-insensitive A-16 descending A-15 duplicates A-14 manual A-17 modifiable A-14 null A-18 segmented A-19 key-only files specifying in description files A-11 updating/deleting records in 1-12 L large data files 1-11 Largest Compressed Record Size configuration option 3-9 Largest Page Size configuration option 3-10 Largest Record Size configuration option 3-10 least-recently-used (LRU) algorithm 1-3 loading (starting) the Btrieve Monitor utility 5-2 the DOS Requester 4-4the OS/2 Requester 4-8 the Rebuild utility 3-19, 3-25 from the command line 3-25 to run interactively 3-19 the Setup utility 3-13 the Windows Requester 4-10 locale-sensitive collating sequences 1-6 locks number of 3-8 using on extended operations log file, checking in the Rebuild utility 3-25 logging feature 5-44 Logging of Selected Files configuration option 3-12 M Maintenance utility 5-14, 5-15 command files 5-19 command format 5-15 commands 5-16 description file elements 5-17 system requirements 5-15 manual, keys, specifying in description files A-17 memory management 1-3 messages B-33 modifiable keys, specifying in description files A-14 monitoring Btrieve activities active files 5-4 active users 5-5 resources in use 5-10 SPX activities 5-12 multiple alternate collating sequences (MACS) 1-6 N NetWare Runtime 3-30 NetWare v3.11 3-1 no currency change option on inserts/updates 1-7 NOVDB.INI, editing 5-54 null, key specifying in description files A-18 value, specifying in description files A-18 Number of Handles configuration option 3-8 Number of Locks configuration option 3-8 Number of Open Files configuration option 3-8 Number of Remote Sessions configuration option 3-11 Number of Transactions configuration option 3-9 O online data file backups 1-9, 5-18 open files, maximum number of 3-8 optional renumbering of keys 1-12 options, configuration for Btrieve 3-7 for the DOS Requester 4-1 for the OS/2 Requester 4-6 for the Windows Requester 4-10 OS/2 Requester 4-5 configuration options 4-6 configuring the 4-8 loading the 4-8 unloading the 4-9 owner names in Btrieve files 1-5, 5-17 P page size largest 3-10 specifying in description files A-10 PBROLL utility. See Roll Forward utility percentage operations 1-7 Perform Index Balancing configuration option 3-11 pointers, reserved duplicate 1-12, A-8 preallocation, specifying in description files A-10 pre-Btrieve v6.0 format 3-12pre-imaging files 1-10, 3-16 R RCONSOLE, accessing the Btrieve Monitor utility 5-1 Rebuild utility 3-17 disk space requirements 3-29 running the from the command line 3-25 interactivel 3-19 rebuilding files interactively with the Rebuild utility 3-19 using the Rebuild utility from the command line 3-25 record length, specifying in description files A-7 size largest 3-9 largest compressed 3-9 recovering changes using the Roll Forward utility 5-43 damaged files 5-32 referential integrity (RI) 1-13 remote sessions, number of 3-11 repeating-duplicatable key 1-7 replacing the existing file, specifying in description files A-11 Requester automatic support for double-byte characters 1-8 DOS 4-1 optional data compression prior to network transmission 1-8 OS/2 4-5 support for NetWare Runtime operating system 1-8 UnixWare 1-8 using the 4-1 Windows 4-9 reserved duplicate pointers 1-12, A-8 retrieving Btrieve records with the Maintenance utility 5-35 Roll Forward utility 5-43 creating BLOG.CFG for use with the 5-45 Options menu of the 5-50, 5-53 preparing to use the 5-44 Queue menu of the 5-50 queuing items in the 5-54 running in a DOS environment 5-47 running in an OS/2 or Windows environment 5-49 setting program options for the 5-50 RSPXSTUB.NLM, unloading 3-16, 3-17, 3-18 S salvaging Btrieve records with the Maintenance utility 5-34 scroll bars, implementing with percentage operations 1-7 security controls 1-5 segmented keys, specifying in description files A-19 selected files, logging 3-12 selecting options from the Available Options menu 5-3 Sequenced Packet Exchange (SPX) 2-2 Setup utility 3-6, 3-7 running the 3-13 shadow paging 1-10 sign trailing separate (STS) data type 1-7 sorting, specifying in description files A-14 SPX communications programs 2-2 standard files, specifying in description files A-11 starting Btrieve 3-17 Stat operation 1-13 statistics for a Btrieve file 5-40 status codes B-1 client-based Btrieve for OS/2 and Windows B-29 Record Manager B-1 Requester B-31 stopping Btrieve 3-18 supplemental index 5-38 support developer xvii technical international xvi telephone xvi system requirements for Btrieve 3-1 for the Btrieve Monitor utility 5-1 for the Maintenance utility 5-15 T technical support international xvi telephone xvi training, product xvii Transaction Tracking System (TTS) flag in the Btrieve Monitor utility 5-10 transactions concurrent 1-9 features 1-10 exclusive 1-9 file-level locking (exclusive) 1-9 number of 3-9 U unloading BROUTER.NLM 3-13, 3-17, 3-18 BSPXCOM.NLM 3-16, 3-17, 3-18 BSPXSTUB.NLM, 3-16, 3-17, 3-18 BTRIEVE.NLM 3-16, 3-17, 3-18 RSPXSTUB 3-16, 3-17, 3-18 upgrading existing files 3-17 UPPER.ALT file 5-25, A-3, A-5 utility Maintenance 5-14 Monitor 5-1 Rebuild 3-17 Roll Forward 5-43 Setup 3-7, 3-13 V variable-length records, specifying in description files A-8 Variable-Tail Allocation Tables (VATs) 1-6, A-12 W WBROLL utility. See Roll Forward utility Windows Requester 4-9 configuration options 4-10 loading the 4-10 unloading the 4-111